package top.zhangjianyong.tools.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import top.zhangjianyong.tools.entity.ETFData;

import java.util.List;
import java.util.Map;

public interface ETFDateMapper extends BaseMapper<ETFData> {
    @Select("SELECT DISTINCT code, `name` from etf_data")
    List<Map<String, String>> listEtf();

    @Select("SELECT DISTINCT code, `name` from etf_data where code like concat(#{code},'%')")
    List<Map<String, String>> search(String code);
}
